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` = 194823 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194823 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (761611,235543,213031,170356,176184,507209,401605,335350,498462,580168,535339,339252,24586,664398,497511,12873,748206,740961,326129,883217,64579,293517,508198,1031452,247893,547110,350017,46574,452076,609384,1016107,859952,472750,111370,388068,225268,728918,441280,1004134,123399,610592,803720,196022,640820,875685,672715,594007,781765,259291,907095,194503,687799,517357,416942,367089,855795,683146,574864,265064,948757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]