SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428871 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428871 [ RunTime:0.003664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742346,463586,710264,136799,424232,737571,430562,892664,61160,76443,128605,726605,158210,686432,896600,118183,566665,1044982,112661,574161,80264,278113,562800,887466,385839,21098,200404,930010,445062,414453,1039399,448119,330155,977719,683878,757972,589595,709958,793380,490299,431733,828175,812430,317289,35735,590394,659193,484841,495938,63910,382905,802587,407743,649438,896895,455876,594518,380839,174775,5212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000778s ]