SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193412 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193412 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419355,754919,607120,347633,781347,193883,341154,136274,1027720,386163,141234,1021599,406206,482563,11241,812885,665140,387632,93018,81533,1012714,100208,111999,33711,872159,923205,533930,134624,499253,331164,1007785,528478,906562,628907,172826,41157,745596,550585,837123,643353,730919,771447,221465,816887,318348,152597,854406,1045519,928898,45349,701557,455779,278741,152724,284572,657688,913561,1029829,299075,854719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]