SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540631 LIMIT 1 [ RunTime:0.001308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540631 [ RunTime:0.002375s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318370,713426,612601,137163,498592,461767,609125,986450,628665,976504,249782,434937,42028,741599,1041371,1046141,454359,747308,332905,832583,725377,506220,372824,1032842,335747,73228,323246,997260,795693,6347,273279,276704,931363,675922,534824,199070,390704,38621,184068,409678,308034,678738,582203,710164,56222,397994,1003928,215251,429312,667639,948924,583854,836379,883368,439111,935747,970878,438767,551675,554954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001773s ]