SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543413 LIMIT 1 [ RunTime:0.001273s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543413 [ RunTime:0.004030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99680,1041738,472352,876218,74454,148395,146240,667664,863154,220182,273451,122113,975601,243004,341764,998940,527209,301671,537291,491362,164505,497685,269620,328266,1035457,443819,368569,63699,700512,770588,457409,582999,292015,725436,118918,147862,1019319,84466,516998,91803,1013687,348695,962439,154984,1015547,374060,684365,930538,132635,23924,810297,76518,108752,710438,636180,23745,168481,369610,32620,240266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]