SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532808 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532808 [ RunTime:0.002459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544338,551046,311722,167320,913774,924065,643358,336461,862290,635556,986276,811945,1014952,438747,392302,952588,688951,774702,781988,565098,521820,848725,526168,435504,362892,897189,1000035,725224,720414,167812,689263,1041395,984708,217539,899374,259341,298659,1046630,934371,230170,505575,365231,42761,582605,800048,626092,651705,131342,758884,617872,458432,1006938,402968,549992,737845,480933,127942,1042752,47448,742062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001212s ]